using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Adex{
    /// <summary>
    /// Strongly-typed collection for the VNewCommercialLog class.
    /// </summary>
    [Serializable]
    public partial class VNewCommercialLogCollection : ReadOnlyList<VNewCommercialLog, VNewCommercialLogCollection>
    {        
        public VNewCommercialLogCollection() {}

    }

    /// <summary>
    /// This is  Read-only wrapper class for the vNewCommercialLog view.
    /// </summary>
    [Serializable]
    public partial class VNewCommercialLog : ReadOnlyRecord<VNewCommercialLog> 
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }

	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }

                return BaseSchema;
            }

        }

    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vNewCommercialLog", TableType.View, DataService.GetInstance("Adex"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = "dbo";
                //columns
                
                TableSchema.TableColumn colvarNewCommercialLogID = new TableSchema.TableColumn(schema);
                colvarNewCommercialLogID.ColumnName = "NewCommercialLogID";
                colvarNewCommercialLogID.DataType = DbType.Int64;
                colvarNewCommercialLogID.MaxLength = 0;
                colvarNewCommercialLogID.AutoIncrement = false;
                colvarNewCommercialLogID.IsNullable = false;
                colvarNewCommercialLogID.IsPrimaryKey = false;
                colvarNewCommercialLogID.IsForeignKey = false;
                colvarNewCommercialLogID.IsReadOnly = false;
                
                schema.Columns.Add(colvarNewCommercialLogID);
                
                TableSchema.TableColumn colvarCountryID = new TableSchema.TableColumn(schema);
                colvarCountryID.ColumnName = "CountryID";
                colvarCountryID.DataType = DbType.Byte;
                colvarCountryID.MaxLength = 0;
                colvarCountryID.AutoIncrement = false;
                colvarCountryID.IsNullable = true;
                colvarCountryID.IsPrimaryKey = false;
                colvarCountryID.IsForeignKey = false;
                colvarCountryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCountryID);
                
                TableSchema.TableColumn colvarRFDate = new TableSchema.TableColumn(schema);
                colvarRFDate.ColumnName = "RFDate";
                colvarRFDate.DataType = DbType.DateTime;
                colvarRFDate.MaxLength = 0;
                colvarRFDate.AutoIncrement = false;
                colvarRFDate.IsNullable = false;
                colvarRFDate.IsPrimaryKey = false;
                colvarRFDate.IsForeignKey = false;
                colvarRFDate.IsReadOnly = false;
                
                schema.Columns.Add(colvarRFDate);
                
                TableSchema.TableColumn colvarTimeStart = new TableSchema.TableColumn(schema);
                colvarTimeStart.ColumnName = "TimeStart";
                colvarTimeStart.DataType = DbType.Int32;
                colvarTimeStart.MaxLength = 0;
                colvarTimeStart.AutoIncrement = false;
                colvarTimeStart.IsNullable = true;
                colvarTimeStart.IsPrimaryKey = false;
                colvarTimeStart.IsForeignKey = false;
                colvarTimeStart.IsReadOnly = false;
                
                schema.Columns.Add(colvarTimeStart);
                
                TableSchema.TableColumn colvarTimeEnd = new TableSchema.TableColumn(schema);
                colvarTimeEnd.ColumnName = "TimeEnd";
                colvarTimeEnd.DataType = DbType.Int32;
                colvarTimeEnd.MaxLength = 0;
                colvarTimeEnd.AutoIncrement = false;
                colvarTimeEnd.IsNullable = true;
                colvarTimeEnd.IsPrimaryKey = false;
                colvarTimeEnd.IsForeignKey = false;
                colvarTimeEnd.IsReadOnly = false;
                
                schema.Columns.Add(colvarTimeEnd);
                
                TableSchema.TableColumn colvarMediaCode = new TableSchema.TableColumn(schema);
                colvarMediaCode.ColumnName = "MediaCode";
                colvarMediaCode.DataType = DbType.Int32;
                colvarMediaCode.MaxLength = 0;
                colvarMediaCode.AutoIncrement = false;
                colvarMediaCode.IsNullable = true;
                colvarMediaCode.IsPrimaryKey = false;
                colvarMediaCode.IsForeignKey = false;
                colvarMediaCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaCode);
                
                TableSchema.TableColumn colvarProductID = new TableSchema.TableColumn(schema);
                colvarProductID.ColumnName = "ProductID";
                colvarProductID.DataType = DbType.Int32;
                colvarProductID.MaxLength = 0;
                colvarProductID.AutoIncrement = false;
                colvarProductID.IsNullable = true;
                colvarProductID.IsPrimaryKey = false;
                colvarProductID.IsForeignKey = false;
                colvarProductID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductID);
                
                TableSchema.TableColumn colvarCategoryID = new TableSchema.TableColumn(schema);
                colvarCategoryID.ColumnName = "CategoryID";
                colvarCategoryID.DataType = DbType.Int32;
                colvarCategoryID.MaxLength = 0;
                colvarCategoryID.AutoIncrement = false;
                colvarCategoryID.IsNullable = true;
                colvarCategoryID.IsPrimaryKey = false;
                colvarCategoryID.IsForeignKey = false;
                colvarCategoryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryID);
                
                TableSchema.TableColumn colvarSectorID = new TableSchema.TableColumn(schema);
                colvarSectorID.ColumnName = "SectorID";
                colvarSectorID.DataType = DbType.Int32;
                colvarSectorID.MaxLength = 0;
                colvarSectorID.AutoIncrement = false;
                colvarSectorID.IsNullable = true;
                colvarSectorID.IsPrimaryKey = false;
                colvarSectorID.IsForeignKey = false;
                colvarSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorID);
                
                TableSchema.TableColumn colvarSubSectorID = new TableSchema.TableColumn(schema);
                colvarSubSectorID.ColumnName = "SubSectorID";
                colvarSubSectorID.DataType = DbType.Int32;
                colvarSubSectorID.MaxLength = 0;
                colvarSubSectorID.AutoIncrement = false;
                colvarSubSectorID.IsNullable = true;
                colvarSubSectorID.IsPrimaryKey = false;
                colvarSubSectorID.IsForeignKey = false;
                colvarSubSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorID);
                
                TableSchema.TableColumn colvarBrandID = new TableSchema.TableColumn(schema);
                colvarBrandID.ColumnName = "BrandID";
                colvarBrandID.DataType = DbType.Int32;
                colvarBrandID.MaxLength = 0;
                colvarBrandID.AutoIncrement = false;
                colvarBrandID.IsNullable = true;
                colvarBrandID.IsPrimaryKey = false;
                colvarBrandID.IsForeignKey = false;
                colvarBrandID.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandID);
                
                TableSchema.TableColumn colvarAdvertiserID = new TableSchema.TableColumn(schema);
                colvarAdvertiserID.ColumnName = "AdvertiserID";
                colvarAdvertiserID.DataType = DbType.Int32;
                colvarAdvertiserID.MaxLength = 0;
                colvarAdvertiserID.AutoIncrement = false;
                colvarAdvertiserID.IsNullable = true;
                colvarAdvertiserID.IsPrimaryKey = false;
                colvarAdvertiserID.IsForeignKey = false;
                colvarAdvertiserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserID);
                
                TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema);
                colvarDateAdded.ColumnName = "DateAdded";
                colvarDateAdded.DataType = DbType.DateTime;
                colvarDateAdded.MaxLength = 0;
                colvarDateAdded.AutoIncrement = false;
                colvarDateAdded.IsNullable = false;
                colvarDateAdded.IsPrimaryKey = false;
                colvarDateAdded.IsForeignKey = false;
                colvarDateAdded.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateAdded);
                
                TableSchema.TableColumn colvarDateModified = new TableSchema.TableColumn(schema);
                colvarDateModified.ColumnName = "DateModified";
                colvarDateModified.DataType = DbType.DateTime;
                colvarDateModified.MaxLength = 0;
                colvarDateModified.AutoIncrement = false;
                colvarDateModified.IsNullable = false;
                colvarDateModified.IsPrimaryKey = false;
                colvarDateModified.IsForeignKey = false;
                colvarDateModified.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateModified);
                
                TableSchema.TableColumn colvarAdvertiserCode = new TableSchema.TableColumn(schema);
                colvarAdvertiserCode.ColumnName = "AdvertiserCode";
                colvarAdvertiserCode.DataType = DbType.Int32;
                colvarAdvertiserCode.MaxLength = 0;
                colvarAdvertiserCode.AutoIncrement = false;
                colvarAdvertiserCode.IsNullable = true;
                colvarAdvertiserCode.IsPrimaryKey = false;
                colvarAdvertiserCode.IsForeignKey = false;
                colvarAdvertiserCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserCode);
                
                TableSchema.TableColumn colvarAdvertiserName = new TableSchema.TableColumn(schema);
                colvarAdvertiserName.ColumnName = "AdvertiserName";
                colvarAdvertiserName.DataType = DbType.String;
                colvarAdvertiserName.MaxLength = 255;
                colvarAdvertiserName.AutoIncrement = false;
                colvarAdvertiserName.IsNullable = true;
                colvarAdvertiserName.IsPrimaryKey = false;
                colvarAdvertiserName.IsForeignKey = false;
                colvarAdvertiserName.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserName);
                
                TableSchema.TableColumn colvarProductCode = new TableSchema.TableColumn(schema);
                colvarProductCode.ColumnName = "ProductCode";
                colvarProductCode.DataType = DbType.Int32;
                colvarProductCode.MaxLength = 0;
                colvarProductCode.AutoIncrement = false;
                colvarProductCode.IsNullable = true;
                colvarProductCode.IsPrimaryKey = false;
                colvarProductCode.IsForeignKey = false;
                colvarProductCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductCode);
                
                TableSchema.TableColumn colvarProductName = new TableSchema.TableColumn(schema);
                colvarProductName.ColumnName = "ProductName";
                colvarProductName.DataType = DbType.String;
                colvarProductName.MaxLength = 255;
                colvarProductName.AutoIncrement = false;
                colvarProductName.IsNullable = true;
                colvarProductName.IsPrimaryKey = false;
                colvarProductName.IsForeignKey = false;
                colvarProductName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductName);
                
                TableSchema.TableColumn colvarMediaName = new TableSchema.TableColumn(schema);
                colvarMediaName.ColumnName = "MediaName";
                colvarMediaName.DataType = DbType.String;
                colvarMediaName.MaxLength = 255;
                colvarMediaName.AutoIncrement = false;
                colvarMediaName.IsNullable = true;
                colvarMediaName.IsPrimaryKey = false;
                colvarMediaName.IsForeignKey = false;
                colvarMediaName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaName);
                
                TableSchema.TableColumn colvarMediaType = new TableSchema.TableColumn(schema);
                colvarMediaType.ColumnName = "MediaTypeCode";
                colvarMediaType.DataType = DbType.Int32;
                colvarMediaType.MaxLength = 0;
                colvarMediaType.AutoIncrement = false;
                colvarMediaType.IsNullable = false;
                colvarMediaType.IsPrimaryKey = false;
                colvarMediaType.IsForeignKey = false;
                colvarMediaType.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaType);
                
                TableSchema.TableColumn colvarMediaTypeName = new TableSchema.TableColumn(schema);
                colvarMediaTypeName.ColumnName = "MediaTypeName";
                colvarMediaTypeName.DataType = DbType.String;
                colvarMediaTypeName.MaxLength = 50;
                colvarMediaTypeName.AutoIncrement = false;
                colvarMediaTypeName.IsNullable = true;
                colvarMediaTypeName.IsPrimaryKey = false;
                colvarMediaTypeName.IsForeignKey = false;
                colvarMediaTypeName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaTypeName);
                
                TableSchema.TableColumn colvarSectorCode = new TableSchema.TableColumn(schema);
                colvarSectorCode.ColumnName = "SectorCode";
                colvarSectorCode.DataType = DbType.Int32;
                colvarSectorCode.MaxLength = 0;
                colvarSectorCode.AutoIncrement = false;
                colvarSectorCode.IsNullable = true;
                colvarSectorCode.IsPrimaryKey = false;
                colvarSectorCode.IsForeignKey = false;
                colvarSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorCode);
                
                TableSchema.TableColumn colvarSectorName = new TableSchema.TableColumn(schema);
                colvarSectorName.ColumnName = "SectorName";
                colvarSectorName.DataType = DbType.String;
                colvarSectorName.MaxLength = 500;
                colvarSectorName.AutoIncrement = false;
                colvarSectorName.IsNullable = true;
                colvarSectorName.IsPrimaryKey = false;
                colvarSectorName.IsForeignKey = false;
                colvarSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorName);
                
                TableSchema.TableColumn colvarSubSectorCode = new TableSchema.TableColumn(schema);
                colvarSubSectorCode.ColumnName = "SubSectorCode";
                colvarSubSectorCode.DataType = DbType.Int32;
                colvarSubSectorCode.MaxLength = 0;
                colvarSubSectorCode.AutoIncrement = false;
                colvarSubSectorCode.IsNullable = true;
                colvarSubSectorCode.IsPrimaryKey = false;
                colvarSubSectorCode.IsForeignKey = false;
                colvarSubSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorCode);
                
                TableSchema.TableColumn colvarSubSectorName = new TableSchema.TableColumn(schema);
                colvarSubSectorName.ColumnName = "SubSectorName";
                colvarSubSectorName.DataType = DbType.String;
                colvarSubSectorName.MaxLength = 500;
                colvarSubSectorName.AutoIncrement = false;
                colvarSubSectorName.IsNullable = true;
                colvarSubSectorName.IsPrimaryKey = false;
                colvarSubSectorName.IsForeignKey = false;
                colvarSubSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorName);
                
                TableSchema.TableColumn colvarBrandCode = new TableSchema.TableColumn(schema);
                colvarBrandCode.ColumnName = "BrandCode";
                colvarBrandCode.DataType = DbType.Int32;
                colvarBrandCode.MaxLength = 0;
                colvarBrandCode.AutoIncrement = false;
                colvarBrandCode.IsNullable = true;
                colvarBrandCode.IsPrimaryKey = false;
                colvarBrandCode.IsForeignKey = false;
                colvarBrandCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandCode);
                
                TableSchema.TableColumn colvarBrandName = new TableSchema.TableColumn(schema);
                colvarBrandName.ColumnName = "BrandName";
                colvarBrandName.DataType = DbType.String;
                colvarBrandName.MaxLength = 255;
                colvarBrandName.AutoIncrement = false;
                colvarBrandName.IsNullable = true;
                colvarBrandName.IsPrimaryKey = false;
                colvarBrandName.IsForeignKey = false;
                colvarBrandName.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandName);
                
                TableSchema.TableColumn colvarCategoryCode = new TableSchema.TableColumn(schema);
                colvarCategoryCode.ColumnName = "CategoryCode";
                colvarCategoryCode.DataType = DbType.Int32;
                colvarCategoryCode.MaxLength = 0;
                colvarCategoryCode.AutoIncrement = false;
                colvarCategoryCode.IsNullable = true;
                colvarCategoryCode.IsPrimaryKey = false;
                colvarCategoryCode.IsForeignKey = false;
                colvarCategoryCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryCode);
                
                TableSchema.TableColumn colvarCategoryName = new TableSchema.TableColumn(schema);
                colvarCategoryName.ColumnName = "CategoryName";
                colvarCategoryName.DataType = DbType.String;
                colvarCategoryName.MaxLength = 255;
                colvarCategoryName.AutoIncrement = false;
                colvarCategoryName.IsNullable = true;
                colvarCategoryName.IsPrimaryKey = false;
                colvarCategoryName.IsForeignKey = false;
                colvarCategoryName.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryName);
                
                TableSchema.TableColumn colvarVideoAudioImage = new TableSchema.TableColumn(schema);
                colvarVideoAudioImage.ColumnName = "VideoAudioImage";
                colvarVideoAudioImage.DataType = DbType.String;
                colvarVideoAudioImage.MaxLength = 300;
                colvarVideoAudioImage.AutoIncrement = false;
                colvarVideoAudioImage.IsNullable = true;
                colvarVideoAudioImage.IsPrimaryKey = false;
                colvarVideoAudioImage.IsForeignKey = false;
                colvarVideoAudioImage.IsReadOnly = false;
                
                schema.Columns.Add(colvarVideoAudioImage);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["Adex"].AddSchema("vNewCommercialLog",schema);
            }

        }

        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }

	    #endregion
	    
	    #region .ctors
	    public VNewCommercialLog()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }

        public VNewCommercialLog(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}

			MarkNew();
	    }

	    
	    public VNewCommercialLog(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }

    	 
	    public VNewCommercialLog(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }

        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("NewCommercialLogID")]
        public long NewCommercialLogID 
	    {
		    get
		    {
			    return GetColumnValue<long>("NewCommercialLogID");
		    }

            set 
		    {
			    SetColumnValue("NewCommercialLogID", value);
            }

        }

	      
        [XmlAttribute("CountryID")]
        public byte? CountryID 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("CountryID");
		    }

            set 
		    {
			    SetColumnValue("CountryID", value);
            }

        }

	      
        [XmlAttribute("RFDate")]
        public DateTime RFDate 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("RFDate");
		    }

            set 
		    {
			    SetColumnValue("RFDate", value);
            }

        }

	      
        [XmlAttribute("TimeStart")]
        public int? TimeStart 
	    {
		    get
		    {
			    return GetColumnValue<int?>("TimeStart");
		    }

            set 
		    {
			    SetColumnValue("TimeStart", value);
            }

        }

	      
        [XmlAttribute("TimeEnd")]
        public int? TimeEnd 
	    {
		    get
		    {
			    return GetColumnValue<int?>("TimeEnd");
		    }

            set 
		    {
			    SetColumnValue("TimeEnd", value);
            }

        }

	      
        [XmlAttribute("MediaCode")]
        public int? MediaCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("MediaCode");
		    }

            set 
		    {
			    SetColumnValue("MediaCode", value);
            }

        }

	      
        [XmlAttribute("ProductID")]
        public int? ProductID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductID");
		    }

            set 
		    {
			    SetColumnValue("ProductID", value);
            }

        }

	      
        [XmlAttribute("CategoryID")]
        public int? CategoryID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryID");
		    }

            set 
		    {
			    SetColumnValue("CategoryID", value);
            }

        }

	      
        [XmlAttribute("SectorID")]
        public int? SectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorID");
		    }

            set 
		    {
			    SetColumnValue("SectorID", value);
            }

        }

	      
        [XmlAttribute("SubSectorID")]
        public int? SubSectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorID");
		    }

            set 
		    {
			    SetColumnValue("SubSectorID", value);
            }

        }

	      
        [XmlAttribute("BrandID")]
        public int? BrandID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("BrandID");
		    }

            set 
		    {
			    SetColumnValue("BrandID", value);
            }

        }

	      
        [XmlAttribute("AdvertiserID")]
        public int? AdvertiserID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AdvertiserID");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserID", value);
            }

        }

	      
        [XmlAttribute("DateAdded")]
        public DateTime DateAdded 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateAdded");
		    }

            set 
		    {
			    SetColumnValue("DateAdded", value);
            }

        }

	      
        [XmlAttribute("DateModified")]
        public DateTime DateModified 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateModified");
		    }

            set 
		    {
			    SetColumnValue("DateModified", value);
            }

        }

	      
        [XmlAttribute("AdvertiserCode")]
        public int? AdvertiserCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AdvertiserCode");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserCode", value);
            }

        }

	      
        [XmlAttribute("AdvertiserName")]
        public string AdvertiserName 
	    {
		    get
		    {
			    return GetColumnValue<string>("AdvertiserName");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserName", value);
            }

        }

	      
        [XmlAttribute("ProductCode")]
        public int? ProductCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductCode");
		    }

            set 
		    {
			    SetColumnValue("ProductCode", value);
            }

        }

	      
        [XmlAttribute("ProductName")]
        public string ProductName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProductName");
		    }

            set 
		    {
			    SetColumnValue("ProductName", value);
            }

        }

	      
        [XmlAttribute("MediaName")]
        public string MediaName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaName");
		    }

            set 
		    {
			    SetColumnValue("MediaName", value);
            }

        }

	      
        [XmlAttribute("MediaType")]
        public int MediaType 
	    {
		    get
		    {
			    return GetColumnValue<int>("MediaTypeCode");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeCode", value);
            }

        }

	      
        [XmlAttribute("MediaTypeName")]
        public string MediaTypeName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaTypeName");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeName", value);
            }

        }

	      
        [XmlAttribute("SectorCode")]
        public int? SectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorCode");
		    }

            set 
		    {
			    SetColumnValue("SectorCode", value);
            }

        }

	      
        [XmlAttribute("SectorName")]
        public string SectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SectorName");
		    }

            set 
		    {
			    SetColumnValue("SectorName", value);
            }

        }

	      
        [XmlAttribute("SubSectorCode")]
        public int? SubSectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorCode");
		    }

            set 
		    {
			    SetColumnValue("SubSectorCode", value);
            }

        }

	      
        [XmlAttribute("SubSectorName")]
        public string SubSectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SubSectorName");
		    }

            set 
		    {
			    SetColumnValue("SubSectorName", value);
            }

        }

	      
        [XmlAttribute("BrandCode")]
        public int? BrandCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("BrandCode");
		    }

            set 
		    {
			    SetColumnValue("BrandCode", value);
            }

        }

	      
        [XmlAttribute("BrandName")]
        public string BrandName 
	    {
		    get
		    {
			    return GetColumnValue<string>("BrandName");
		    }

            set 
		    {
			    SetColumnValue("BrandName", value);
            }

        }

	      
        [XmlAttribute("CategoryCode")]
        public int? CategoryCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryCode");
		    }

            set 
		    {
			    SetColumnValue("CategoryCode", value);
            }

        }

	      
        [XmlAttribute("CategoryName")]
        public string CategoryName 
	    {
		    get
		    {
			    return GetColumnValue<string>("CategoryName");
		    }

            set 
		    {
			    SetColumnValue("CategoryName", value);
            }

        }

	      
        [XmlAttribute("VideoAudioImage")]
        public string VideoAudioImage 
	    {
		    get
		    {
			    return GetColumnValue<string>("VideoAudioImage");
		    }

            set 
		    {
			    SetColumnValue("VideoAudioImage", value);
            }

        }

	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string NewCommercialLogID = @"NewCommercialLogID";
            
            public static string CountryID = @"CountryID";
            
            public static string RFDate = @"RFDate";
            
            public static string TimeStart = @"TimeStart";
            
            public static string TimeEnd = @"TimeEnd";
            
            public static string MediaCode = @"MediaCode";
            
            public static string ProductID = @"ProductID";
            
            public static string CategoryID = @"CategoryID";
            
            public static string SectorID = @"SectorID";
            
            public static string SubSectorID = @"SubSectorID";
            
            public static string BrandID = @"BrandID";
            
            public static string AdvertiserID = @"AdvertiserID";
            
            public static string DateAdded = @"DateAdded";
            
            public static string DateModified = @"DateModified";
            
            public static string AdvertiserCode = @"AdvertiserCode";
            
            public static string AdvertiserName = @"AdvertiserName";
            
            public static string ProductCode = @"ProductCode";
            
            public static string ProductName = @"ProductName";
            
            public static string MediaName = @"MediaName";
            
            public static string MediaType = @"MediaTypeCode";
            
            public static string MediaTypeName = @"MediaTypeName";
            
            public static string SectorCode = @"SectorCode";
            
            public static string SectorName = @"SectorName";
            
            public static string SubSectorCode = @"SubSectorCode";
            
            public static string SubSectorName = @"SubSectorName";
            
            public static string BrandCode = @"BrandCode";
            
            public static string BrandName = @"BrandName";
            
            public static string CategoryCode = @"CategoryCode";
            
            public static string CategoryName = @"CategoryName";
            
            public static string VideoAudioImage = @"VideoAudioImage";
            
	    }

	    #endregion
    }

}

